SaEnrollRevenueChildTerm 
Logical Entity Name  SaEnrollRevenueChildTerm 
Default Table Name  SaEnrollRevenueChildTerm 
Physical Only  NO 
Definition 
 
Note 
 

SaEnrollRevenueChildTerm Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SaEnrollRevenueChildTermID(PK)    int  NO 
 
SaEnrollRevenueID(FK)    int  NO 
 
AdEnrollID(FK)    int  NO 
 
AcademicYear    numeric(3, 0)  NO 
 
AdTermID(FK)    int  YES 
 
SaBillCode    char(8)  NO 
 
BillingFrequency    char(1)  NO 
 
FutureRevenue    money  NO 
 
RevenueEarned    money  NO 
 
TotalRevenueUnits    numeric(8, 2)  NO 
 
RevenueUnitsEarned    numeric(8, 2)  NO 
 
ExceptionCode    char(1)  YES 
 
LastEarnDate    datetime  YES 
 
SyCampusID(FK)    int  NO 
 
FullMonthAmount    money  NO 
 
LastEarnAmount    money  NO 
 
PeriodBeginDate    datetime  YES 
 
PeriodEndDate    datetime  YES 
 
ManualOverride    bit  NO 
 
RevenueBasis    char(1)  YES 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID(FK)    int  NO 
 
ts    timestamp  NO 
 

SaEnrollRevenueChildTerm Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_SaEnrollRevenueChildTermID  PrimaryKey  SaEnrollRevenueChildTermID 

SaEnrollRevenueChildTerm Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdEnroll  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_AdEnrollID_AdEnroll_AdEnrollID      AdEnrollID  NO  YES 
AdTerm  Non-Identifying  Zero or One to Zero or More  FK_SaEnrollRevenueChildTerm_AdTermID_AdTerm_AdTermID      AdTermID  NO  YES 
SaEnrollRevenue  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_SaEnrollRevenueID_SaEnrollRevenue_SaEnrollRevenueID      SaEnrollRevenueID  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_SyCampusID_SyCampus_SyCampusID      SyCampusID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
SaRevenueDetail  Non-Identifying  One To Zero or More  FK_SaRevenueDetail_SaEnrollRevenueChildTermID_SaEnrollRevenueChildTerm_SaEnrollRevenueChildTermID        NO  YES 

SaEnrollRevenueChildTerm Check Constraints 
Check Constraint Name  CheckConstraint